
import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.logging.Level;

public class FishingMySQLSource extends FishingDataSource {

    private String driver, username, password, db;

    private Connection getConnection() {
        try {
            return DriverManager.getConnection(db + "?autoReconnect=true&user=" + username + "&password=" + password);
        } catch (SQLException ex) {
            log.log(Level.SEVERE, "Unable to retreive connection", ex);
        }
        return null;
    }

    public void initialize() {

        try {
            Class.forName(driver);
        } catch (ClassNotFoundException ex) {
            log.log(Level.SEVERE, "Unable to find class " + driver, ex);
        }

        loadBooks();
    }

    public void loadBooks() {
        // blank for compilation
    }

    @Override
    public void loadFish() {
        throw new UnsupportedOperationException("Not supported yet.");
    }

    @Override
    public void loadBucket() {
        throw new UnsupportedOperationException("Not supported yet.");
    }

    @Override
    public void addBucket(Bucket bucket) {
        throw new UnsupportedOperationException("Not supported yet.");
    }

    @Override
    public void removeBucket(Bucket bucket) {
        throw new UnsupportedOperationException("Not supported yet.");
    }
}
